{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Exception Memo","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Exception Memo","index":0,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,0,17,4]]}
["MEMORANDUM"]
[]
["TO:","Allen H. Myers, P.E."]
[null,"Director, Division of Materials"]
[]
["FROM:"]
[]
[]
[]
["DATE:"]
[]
["RE:"]
[null,""]
[null,"Sampling and Testing Deficiencies"]
[]
[]
["The following materials were not sampled and tested as required because:"]
[]
[]
["Line Item","Description","Component Material","Installed Quantity","Deficiency"]

{"sheet":"Data","index":1,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["District # 1",null,"No Sample Obtained","CONT_ID","PRJ_NBR","LN_ITM_NBR","ITM_CD","LAST_CHNG_YR","ITM_MSTR_SHRT_DESC","QTY_INSTL_TO_DT","UNT_T"]
["District # 2",null,"Insufficient Number of Samples Obtained"]
["District # 3",null,"Sample Destroyed/Mishandled"]
["District # 4",null,"Sample Lost After Being Obtained"]
["District # 5",null,"Lost/Destroyed Test Results"]
["District # 6",null,"Data Entry Error"]
["District # 7",null,"No Certification Obtained"]
["District # 8",null,"Insufficient Number of Certifications Obtained"]
["District # 9",null,"No Visual Acceptance Performed"]
["District # 10",null,"Insufficient Number of Visual Acceptances Performed"]
["District # 11",null,"Concrete Mix Design Not Obtained"]
["District # 12",null,"Asphalt Mix Design Not Obtained"]
[null,null,"Nuclear Densities Not Performed"]
[null,null,"No IA Performed"]
[null,null,"Insufficient Number of IA Tests Performed"]
[{"$f":"CONCATENATE(RIGHT('Exception Memo'!B12,6) & \"         \")","v":"         "},null,"Zinc Coating Test Not Performed"]
[{"$f":"IF('Exception Memo'!B13=\"\",\"\",RIGHT('Exception Memo'!B13,LEN('Exception Memo'!B13)))","v":""},null,"Other"]
[{"$f":"IF(A17=\"\",\"\",RIGHT(A17,LEN(A17)-11))","v":""}]